SetConditionalFormatting(Int32,Int32,Int32,Int32,IConditionalFormattingRule[]) Method

In This Topic

Sets conditional formatting for a specified range of cells on the sheet based on specified rules.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Sub SetConditionalFormatting( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal rowCount As Integer, _
   ByVal columnCount As Integer, _
   ByVal ParamArray rules() As IConditionalFormattingRule _
)

'Usage
 
Dim instance As SheetView
Dim row As Integer
Dim column As Integer
Dim rowCount As Integer
Dim columnCount As Integer
Dim rules() As IConditionalFormattingRule
 
instance.SetConditionalFormatting(row, column, rowCount, columnCount, rules)

public void SetConditionalFormatting( 
   int row,
   int column,
   int rowCount,
   int columnCount,
   params IConditionalFormattingRule[] rules
)

Parameters

row: Starting row index
column: Starting column index
rowCount: Number of rows
columnCount: Number of columns
rules: The specified rules to apply for a specified range of cells

Example

This example uses the SetConditionalFormatting method.

C#
VB.NET

Reference

SheetView Class
SheetView Members
Overload List